home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / deleteData.sql < prev    next >
Text File  |  2000-05-12  |  2KB  |  68 lines
  1. /* RCSVER $Id: deleteData.sql,v 1.4 1999-07-29 16:28:05-05 randy CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        deleteData.sql
  6. * Date:        02/17/1999
  7. * memo:        Randy Wood
  8. * Description:    Delete the data from the data (NOT config) tables.
  9. * Changes:
  10. ************************************************************************* */
  11. DELETE FROM fare_context;
  12. DELETE FROM loadok;
  13. DELETE FROM driver_context;
  14. DELETE FROM operator_context;
  15. DELETE FROM probe_context;
  16. DELETE FROM waysvc;
  17. DELETE FROM wayissue;
  18. DELETE FROM wayevnt;
  19. DELETE FROM wayvalpass;
  20. DELETE FROM probesucc;
  21. DELETE from probefail;
  22. DELETE FROM cbdooro;
  23. DELETE FROM cbdoorc;
  24. DELETE FROM jcdooro;
  25. DELETE FROM jcdoorc;
  26. DELETE FROM cblatch;
  27. DELETE FROM cbunlatch;
  28. DELETE FROM badcbid;
  29. DELETE FROM cbdooru;
  30. DELETE FROM sboveroff;
  31. DELETE FROM conpwrb;
  32. DELETE FROM conpwre;
  33. DELETE FROM escapek;
  34. DELETE FROM fbconfig;
  35. DELETE FROM cbinsert;
  36. DELETE FROM cbremov;
  37. DELETE FROM alarmact;
  38. DELETE FROM alarmclr;
  39. DELETE FROM bitstat;
  40. DELETE FROM cmdinit;
  41. DELETE FROM invalsec;
  42. DELETE FROM supersec;
  43. DELETE FROM fschng;
  44. DELETE FROM rtechng;
  45. DELETE FROM shftrele;
  46. DELETE FROM shftrels;
  47. DELETE FROM fareentr;
  48. DELETE FROM shftstrt;
  49. DELETE FROM shftend;
  50. DELETE FROM csposto;
  51. DELETE FROM cskeycnt;
  52. DELETE FROM cscurcnt;
  53. DELETE FROM cscrash;
  54. DELETE FROM curstate;
  55. DELETE FROM psettime;
  56. DELETE FROM staket;
  57. DELETE FROM settime;
  58. DELETE FROM startup;
  59. DELETE FROM curacc;
  60. DELETE FROM fberror;
  61. DELETE FROM fbpwrfal;
  62. DELETE FROM sboveron;
  63. DELETE FROM convexcp;
  64. DELETE FROM mstrrec;
  65. DELETE FROM probehist;
  66. DELETE FROM convert;
  67. DELETE FROM cashboxloc;
  68.